from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class ConsumptionRestriction(Base):
    __tablename__ = "TYC_JR_CONSUMPTION_RESTRICTION"
    CASECODE = Column(String(255))
    QYINFOALIAS   = Column(String(255))
    FILEPATH   = Column(String(255))
    QYINFO   = Column(String(255))
    CASECREATETIME  = Column(Integer)
    ALIAS  = Column(String(255))
    ID  = Column(Integer,primary_key=True)
    XNAME  = Column(String(255))
    CID  = Column(Integer)
    HCGID  = Column(String(255))
    APPLICANT  = Column(String(255))
    APPLICANTCID  = Column(String(255))
    PUBLISHDATE = Column(Integer)

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)